package com.istock.monitor.agent.sql;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;

public class MyStatement implements Statement {
	private final Statement statement;

	protected final MySql mysql;

	public MyStatement(Statement statement) throws SQLException {
		this.statement = statement;
		this.mysql = new MySql();

		if (statement instanceof PreparedStatement) {
			mysql.setParameterCount(((PreparedStatement) statement).getParameterMetaData().getParameterCount());
		}
	}

	@Override
	public ResultSet executeQuery(String sql) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			ResultSet result = statement.executeQuery(sql);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeQuery");
		}
	}

	@Override
	public int executeUpdate(String sql) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			int result = statement.executeUpdate(sql);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeUpdate");
		}
	}

	@Override
	public void close() throws SQLException {
		mysql.clearSql();
		mysql.clearBatchSqls();
		mysql.clearParameters();
		mysql.clearBatch();
		
		statement.close();
	}

	@Override
	public int getMaxFieldSize() throws SQLException {
		return statement.getMaxFieldSize();
	}

	@Override
	public void setMaxFieldSize(int max) throws SQLException {
		statement.setMaxFieldSize(max);
	}

	@Override
	public int getMaxRows() throws SQLException {
		return statement.getMaxRows();
	}

	@Override
	public void setMaxRows(int max) throws SQLException {
		statement.setMaxRows(max);
	}

	@Override
	public void setEscapeProcessing(boolean enable) throws SQLException {
		statement.setEscapeProcessing(enable);
	}

	@Override
	public int getQueryTimeout() throws SQLException {
		return statement.getQueryTimeout();
	}

	@Override
	public void setQueryTimeout(int seconds) throws SQLException {
		statement.setQueryTimeout(seconds);
	}

	@Override
	public void cancel() throws SQLException {
		statement.cancel();
	}

	@Override
	public SQLWarning getWarnings() throws SQLException {
		return statement.getWarnings();
	}

	@Override
	public void clearWarnings() throws SQLException {
		statement.clearWarnings();
	}

	@Override
	public void setCursorName(String name) throws SQLException {
		statement.setCursorName(name);
	}

	@Override
	public boolean execute(String sql) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			boolean result = statement.execute(sql);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("execute");
		}
	}

	@Override
	public ResultSet getResultSet() throws SQLException {
		return statement.getResultSet();
	}

	@Override
	public int getUpdateCount() throws SQLException {
		return statement.getUpdateCount();
	}

	@Override
	public boolean getMoreResults() throws SQLException {
		return statement.getMoreResults();
	}

	@Override
	public void setFetchDirection(int direction) throws SQLException {
		statement.setFetchDirection(direction);
	}

	@Override
	public int getFetchDirection() throws SQLException {
		return statement.getFetchDirection();
	}

	@Override
	public void setFetchSize(int rows) throws SQLException {
		statement.setFetchSize(rows);
	}

	@Override
	public int getFetchSize() throws SQLException {
		return statement.getFetchSize();
	}

	@Override
	public int getResultSetConcurrency() throws SQLException {
		return statement.getResultSetConcurrency();
	}

	@Override
	public int getResultSetType() throws SQLException {
		return statement.getResultSetType();
	}

	@Override
	public void addBatch(String sql) throws SQLException {
		mysql.addBatchSql(sql);
		statement.addBatch(sql);
	}

	@Override
	public void clearBatch() throws SQLException {
		mysql.clearBatch();
		mysql.clearBatchSqls();
		statement.clearBatch();
	}

	@Override
	public int[] executeBatch() throws SQLException {
		long begin = System.currentTimeMillis();
		try {
			int[] result = statement.executeBatch();
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeBatch");
		}
	}

	@Override
	public Connection getConnection() throws SQLException {
		return statement.getConnection();
	}

	@Override
	public boolean getMoreResults(int current) throws SQLException {
		return statement.getMoreResults(current);
	}

	@Override
	public ResultSet getGeneratedKeys() throws SQLException {
		return statement.getGeneratedKeys();
	}

	@Override
	public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			int result = statement.executeUpdate(sql, autoGeneratedKeys);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeUpdate");
		}
	}

	@Override
	public int executeUpdate(String sql, int[] columnIndexes) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			int result = statement.executeUpdate(sql, columnIndexes);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeUpdate");
		}
	}

	@Override
	public int executeUpdate(String sql, String[] columnNames) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			int result = statement.executeUpdate(sql, columnNames);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("executeUpdate");
		}
	}

	@Override
	public boolean execute(String sql, int autoGeneratedKeys) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			boolean result = statement.execute(sql, autoGeneratedKeys);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("execute");
		}
	}

	@Override
	public boolean execute(String sql, int[] columnIndexes) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			boolean result = statement.execute(sql, columnIndexes);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("execute");
		}
	}

	@Override
	public boolean execute(String sql, String[] columnNames) throws SQLException {
		long begin = System.currentTimeMillis();
		mysql.setSql(sql);
		try {
			boolean result = statement.execute(sql, columnNames);
			mysql.setSuccess(true);
			return result;
		} catch (SQLException e) {
			mysql.setSuccess(false);
			throw e;
		} finally {
			mysql.setProcessTime(System.currentTimeMillis() - begin);
			mysql.setHasTransaction(!statement.getConnection().getAutoCommit());
			commitEvent("execute");
		}
	}

	@Override
	public int getResultSetHoldability() throws SQLException {
		return statement.getResultSetHoldability();
	}

	@Override
	public boolean isClosed() throws SQLException {
		return statement.isClosed();
	}

	@Override
	public void setPoolable(boolean poolable) throws SQLException {
		statement.setPoolable(poolable);
	}

	@Override
	public boolean isPoolable() throws SQLException {
		return statement.isPoolable();
	}

	@Override
	public void closeOnCompletion() throws SQLException {
		mysql.clearSql();
		mysql.clearBatchSqls();
		mysql.clearParameters();
		mysql.clearBatch();
		
		statement.closeOnCompletion();
	}

	@Override
	public boolean isCloseOnCompletion() throws SQLException {
		return statement.isCloseOnCompletion();
	}

	@Override
	public <T> T unwrap(Class<T> iface) throws SQLException {
		return statement.unwrap(iface);
	}

	@Override
	public boolean isWrapperFor(Class<?> iface) throws SQLException {
		return statement.isWrapperFor(iface);
	}
	
	void setSql(String sql) {
		mysql.setSql(sql);
	}
	
	protected void commitEvent(String name) throws SQLException {
		System.out.println("============commit==================");
	}

}
